/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sv.com.intesal.rrhh.sql;

/**
 *
 * @author JM
 */
public class SQLArea {
    /* sql's para cArea */

    public static final String areaInsertar = "INSERT INTO area(nombre_a) VALUES(?)";
    public static final String areaBuscar = "SELECT * FROM AREA order by nombre_a";
    public static final String areaUpdate = "UPDATE AREA set nombre_a=? where id_a=?";
    public static final String areaDelete = "DELETE FROM AREA WHERE id_a=?";

//    public static final String areaExistente = "SELECT count(id_a) FROM AREA WHERE id_a=?";
    
    public static final String areaBuscarLike = "SELECT * FROM AREA WHERE nombre_a like ? order by nombre_a";
}
